enq: TT - contention
Enqueue wait. Temporary Table.
Additional Information​
An enqueue is a wait for a resource held by another.
enq: TT - contention is seen when tablespace DDL operations are serialized on temporary tablespaces. This can be tablespace creation or point in time recovery (PITR).
How to reduce this wait​
Safi’s article references this SQL credited to The Definitive Guide to identify lock holders and waiters.
SELECT DECODE(request, 0, 'Holder: ', 'Waiter: ') || sid sid, id1, id2, lmode, request, TYPE, inst_id FROM GV$LOCK WHERE (id1, id2, TYPE) IN (SELECT id1, id2, TYPE FROM GV$LOCK WHERE request > 0) ORDER BY id1,request
Additional Links​
Oracle Docs - Oracle Enqueue Names
Safi Mohammad - enq: TT contention
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.